/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.132_res
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 192.168.1.132
 Source Database       : resdir

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : utf-8

 Date: 06/17/2020 15:08:32 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `flow_histories`
-- ----------------------------
DROP TABLE IF EXISTS `flow_histories`;
CREATE TABLE `flow_histories` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `requirement_id` int(11) DEFAULT NULL COMMENT '需要流转的需求id',
  `flow_initate_dept_id` int(11) DEFAULT NULL COMMENT '流转发起部门id',
  `flow_initate_dept_name` varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流转发起部门名称',
  `flow_receive_dept_id` int(11) DEFAULT NULL COMMENT '流转接收部门id',
  `flow_receive_dept_name` varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流转接收部门名称',
  `flow_start_time` datetime DEFAULT NULL COMMENT '流转开始时间',
  `folw_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流转原因',
  `flow_num` varchar(0) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流转单号',
  `requirement_state` int(11) DEFAULT NULL COMMENT '状态(1.待处理 2.已流转 3.已回复)',
  `is_start` int(11) DEFAULT NULL COMMENT '是否是发起(0. 否 1.是)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='互动交流-流转历史记录';

-- ----------------------------
--  Records of `flow_histories`
-- ----------------------------
BEGIN;
INSERT INTO `flow_histories` VALUES ('61', '35', '22997', '市数据资源管理局', '22997', '市数据资源管理局', '2020-04-24 10:51:41', null, null, '1', '1'), ('62', '36', '22997', '市数据资源管理局', '22997', '市数据资源管理局', '2020-06-09 15:09:51', null, null, '1', '1'), ('63', '37', '1', '浙江省', '22997', '市数据资源管理局', '2020-06-15 11:27:15', null, null, '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `rd_data_provider`
-- ----------------------------
DROP TABLE IF EXISTS `rd_data_provider`;
CREATE TABLE `rd_data_provider` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `data_num` int(11) DEFAULT NULL COMMENT '序号',
  `fiele_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段名',
  `fiele_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段类型',
  `fiele_length` int(11) DEFAULT NULL COMMENT '字段长度',
  `fiele_accuracy` int(11) DEFAULT NULL COMMENT '字段精度',
  `field_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段描述',
  `primary_key` int(11) DEFAULT NULL COMMENT '是否是主键（1.是 2.否）',
  `operation` int(11) DEFAULT NULL COMMENT '操作（1.增 2.删 3.改 4.查）',
  `res_cataloging_id` int(11) DEFAULT NULL COMMENT '资源目录id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='数据提供';

-- ----------------------------
--  Table structure for `rd_db_app`
-- ----------------------------
DROP TABLE IF EXISTS `rd_db_app`;
CREATE TABLE `rd_db_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请单号',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `db_id` int(11) DEFAULT NULL COMMENT 'rd_db_dict主键',
  `item_id` int(11) DEFAULT NULL COMMENT 'item主键',
  `e_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段英文名',
  `c_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段中文名',
  `field_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段类型',
  `field_length` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段长度',
  `field_accuracy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段精度',
  `keywords` int(11) DEFAULT NULL COMMENT '是否主键（1.是 2.否）',
  `version_num` int(11) DEFAULT NULL COMMENT '版本号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='数据源数据绑定申请单\r\n';

-- ----------------------------
--  Records of `rd_db_app`
-- ----------------------------
BEGIN;
INSERT INTO `rd_db_app` VALUES ('103', '20200420103608505327-500', '500', '160', '606', 'name', '姓名', 'char', '255', '1', '1', '1'), ('104', '20200420103608505327-500', '663', '160', '606', 'name', '姓名', 'char', '255', '1', '1', null), ('105', '20200422174813074244-500', '500', '161', '606', 'name', '姓名', 'char', '255', '1', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_db_dict`
-- ----------------------------
DROP TABLE IF EXISTS `rd_db_dict`;
CREATE TABLE `rd_db_dict` (
  `db_id` int(32) NOT NULL AUTO_INCREMENT COMMENT '库id',
  `db_desc` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '库描述',
  `db_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip地址',
  `db_port` int(11) DEFAULT NULL COMMENT '端口',
  `db_user` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户名',
  `db_passwd` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密码',
  `db_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '数据库名',
  `db_type` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '数据库类型',
  `dept_id` int(11) DEFAULT NULL COMMENT '所属部门id',
  `dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '所属部门名称',
  PRIMARY KEY (`db_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='数据源配置';

-- ----------------------------
--  Records of `rd_db_dict`
-- ----------------------------
BEGIN;
INSERT INTO `rd_db_dict` VALUES ('160', 'resdir', '192.168.1.132', '3306', 'resdir', 'resdir123456', 'resdir', 'MYSQL', '37', '省政府办公厅'), ('161', '数据源1', '192.168.1.132', '3306', 'approval', 'approval123654', 'approval', 'MYSQL', '35', '省人大'), ('162', 'user-center', '192.168.1.132', '3306', 'usercenter', 'uc123456', 'usercenter', 'MYSQL', '1', '浙江省');
COMMIT;

-- ----------------------------
--  Table structure for `rd_dir_data_update_log`
-- ----------------------------
DROP TABLE IF EXISTS `rd_dir_data_update_log`;
CREATE TABLE `rd_dir_data_update_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_catalog_id` int(11) DEFAULT NULL COMMENT '关联的资源编目ID',
  `update_user_id` int(11) DEFAULT NULL COMMENT '变更人ID',
  `update_user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '变更人名称',
  `update_time` datetime DEFAULT NULL COMMENT '变更时间',
  `update_type` int(3) DEFAULT NULL COMMENT '变更操作类型:0-新增 1-编辑',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='保存资源目录修改历史';

-- ----------------------------
--  Records of `rd_dir_data_update_log`
-- ----------------------------
BEGIN;
INSERT INTO `rd_dir_data_update_log` VALUES ('283', '162', '234', '申陶宜', '2020-04-18 21:52:46', '0'), ('284', '163', '234', '申陶宜', '2020-04-20 15:04:44', '0'), ('285', '164', '234', '申陶宜', '2020-04-21 18:47:08', '0'), ('286', '165', '234', '申陶宜', '2020-04-22 11:10:47', '0'), ('287', '166', '234', '申陶宜', '2020-04-22 16:23:55', '0'), ('288', '167', '234', '申陶宜', '2020-04-22 16:37:36', '0'), ('289', '168', '234', '申陶宜', '2020-04-27 15:48:42', '0'), ('290', '169', '234', '申陶宜', '2020-04-27 15:50:35', '0');
COMMIT;

-- ----------------------------
--  Table structure for `rd_implementation_order`
-- ----------------------------
DROP TABLE IF EXISTS `rd_implementation_order`;
CREATE TABLE `rd_implementation_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单号',
  `implementation_state` int(3) DEFAULT NULL COMMENT '实施状态 0 实施中 1实施完成 2 已中止 3已回收 4资源待回收)',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) DEFAULT NULL COMMENT '申请用户id',
  `res_id` int(11) DEFAULT NULL COMMENT '资源ID',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `res_unique_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源唯一标识',
  `implementation_work_order` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '实施工单号',
  `res_type` int(3) DEFAULT NULL COMMENT '资源类型',
  `resource_consumers` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请部门名称',
  `approval_time` datetime DEFAULT NULL COMMENT '审批时间',
  `res_state` int(3) DEFAULT NULL COMMENT '资源状态 0 异常 1-正常',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `firmly_state` int(11) DEFAULT NULL COMMENT '未上线资源实施工单确认情况（1.提供部门已确认，2.数据局已确认）',
  `order_type` int(11) DEFAULT NULL COMMENT '工单类型（1.申请使用，2.申请上线）',
  `cancel_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '取消实施的理由',
  `preselect_res_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '预选资源类型(1.服务接口类 2.服务页面类 3.数据交换类)',
  `finish_userid` int(11) DEFAULT NULL COMMENT '确认实施完成人员的id',
  `finish_username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '确认实施完成人员的用户名',
  `service_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '服务地址',
  PRIMARY KEY (`id`),
  KEY `idx_apply_num` (`apply_num`)
) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='实施工单';

-- ----------------------------
--  Records of `rd_implementation_order`
-- ----------------------------
BEGIN;
INSERT INTO `rd_implementation_order` VALUES ('223', '20200420103608505327-500', '3', '22997', '237', '500', '浙江省户口迁移准许接口申请', '376c52fb-d8b9-4b64-9df7-31093a5b583d', '1587353133321', '3', '省政府办公厅', '2020-04-20 11:25:33', '1', null, null, '1', '2222', '3', null, null, null), ('224', '20200420150818689317-518', '1', '22997', '237', '518', '晚婚晚育人员信息查询接口', '88c825e5-7865-421e-8080-961875e88515', '1587366549563', '2', '省政府办公厅', '2020-04-20 15:09:10', '1', null, null, '2', null, '3', '235', '锐嘉良', null), ('225', '20200420145317873961-501', '1', '22997', '237', '501', '全国互联网地图信息查询', 'da634860-5cd1-486a-8b8f-f687187a97e7', '1587437564946', '1', '省政府办公厅', '2020-04-21 10:52:45', '1', null, null, '1', 'lj', '1', null, null, null), ('227', '20200422101847599725-502', '1', '22997', '237', '502', '浙江杭州规划和自然资源局天地图信息查询（leaflet）', '3c044e27-0a0e-4851-b272-cc4caec30f7a', '1587521990292', '1', '省政府办公厅', '2020-04-22 10:19:50', '1', null, null, '1', '申请回收', '1', null, null, null), ('229', '20200422163806819280-522', '2', '22997', '233', '522', '接口服务模拟', '06286c09-3009-49be-8466-886e29d3ed68', '1587546054860', null, '省人大', '2020-04-22 17:00:55', '1', null, null, '2', '111', '3', '235', '锐嘉良', null), ('230', '20200422171749800747-501', '1', '22997', '233', '501', '全国互联网地图信息查询', 'da634860-5cd1-486a-8b8f-f687187a97e7', '1587547209281', '1', '省人大', '2020-04-22 17:20:09', '1', null, null, '1', '啊恶气', '1', null, null, null), ('231', '20200421104150664604-518', '0', '22997', '237', '518', '晚婚晚育人员信息查询接口', '88c825e5-7865-421e-8080-961875e88515', '1587957038436', '2', '省政府办公厅', '2020-04-27 11:10:38', '1', null, null, '1', null, '2', null, null, null), ('232', '20200427110427741360-506', '1', '22997', '233', '506', '浙江杭州民政局低保人口信息查询', '542c9ca6-34fc-4b09-baa1-c5273ffaa939', '1587957118699', '1', '省人大', '2020-04-27 11:11:59', '1', null, null, '1', null, '1', null, null, null), ('233', '20200422174813074244-500', '1', '22997', '233', '500', '浙江省户口迁移准许接口申请', '376c52fb-d8b9-4b64-9df7-31093a5b583d', '1587957120818', '3', '省人大', '2020-04-27 11:12:01', '1', null, null, '1', null, '3', null, null, null), ('234', '20200427160608252425-524', '1', '22997', '233', '524', '城市红码人员信息查询', '0684e7f2-7918-419f-8ad0-545948d98ff9', '1587974805363', '1', '省人大', '2020-04-27 16:06:45', '1', null, null, '1', null, '1', null, null, null), ('235', '20200427160527558468-523', '1', '22997', '233', '523', '城市绿码申请人员信息查询', 'd75c5251-0939-4128-a653-7ec9bfc72ed2', '1587974811452', '1', '省人大', '2020-04-27 16:06:51', '1', null, null, '1', null, '1', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_interface_information`
-- ----------------------------
DROP TABLE IF EXISTS `rd_interface_information`;
CREATE TABLE `rd_interface_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `interface_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口名称',
  `creat_time` datetime DEFAULT NULL COMMENT '创建时间',
  `interface_add` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口地址',
  `request_type` int(11) DEFAULT NULL COMMENT '请求方式（1.POST  2.GET）',
  `support_format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '支持格式',
  `interface_specification` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口说明',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新人员id',
  `own_res_id` int(11) DEFAULT NULL COMMENT '所属资源Api ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='接口信息';

-- ----------------------------
--  Table structure for `rd_ip_change`
-- ----------------------------
DROP TABLE IF EXISTS `rd_ip_change`;
CREATE TABLE `rd_ip_change` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` int(3) DEFAULT NULL COMMENT '变动类型: 0-新增 1-修改 2-删除',
  `app_id` int(11) DEFAULT NULL COMMENT '自建系统ID',
  `old_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '旧IP地址',
  `new_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '新IP地址',
  `aims_id` int(11) DEFAULT NULL COMMENT '如果是修改，则指定要修改的数据的ID,否则为null即可',
  `old_res_id_list` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '旧资源ID列表',
  `new_res_id_list` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '新资源ID列表',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=794 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='保存ip变更记录，用于ip修改申请单完成后发放申请的内容';

-- ----------------------------
--  Records of `rd_ip_change`
-- ----------------------------
BEGIN;
INSERT INTO `rd_ip_change` VALUES ('792', '1', '96', '10.1.12.163', '10.1.12.166', '287', '501', '501', '2020-04-21 10:56:40'), ('793', '1', '98', '166.152.152.155', '166.152.152.155', '292', null, '501', '2020-04-26 17:34:11');
COMMIT;

-- ----------------------------
--  Table structure for `rd_ip_imple_order`
-- ----------------------------
DROP TABLE IF EXISTS `rd_ip_imple_order`;
CREATE TABLE `rd_ip_imple_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id主键',
  `apply_num` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order_no` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '实施工单号',
  `app_id` int(11) DEFAULT NULL COMMENT '自建系统唯一编码',
  `ip_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '操作ip的ID列表,此处关联ip_change表',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) DEFAULT NULL COMMENT '申请人id',
  `type` int(3) DEFAULT NULL COMMENT '操作类型0-新增 1-修改 2-删除',
  `state` int(3) DEFAULT NULL COMMENT '实施状态 0-待实施 1-实施完成',
  `create_time` datetime DEFAULT NULL COMMENT '申请日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=414 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ip实施工单';

-- ----------------------------
--  Records of `rd_ip_imple_order`
-- ----------------------------
BEGIN;
INSERT INTO `rd_ip_imple_order` VALUES ('1', null, null, null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_ip_save`
-- ----------------------------
DROP TABLE IF EXISTS `rd_ip_save`;
CREATE TABLE `rd_ip_save` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip',
  `creat_user_id` int(11) DEFAULT NULL COMMENT '创建人id',
  `creat_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ip存储表';

-- ----------------------------
--  Table structure for `rd_ip_update_application`
-- ----------------------------
DROP TABLE IF EXISTS `rd_ip_update_application`;
CREATE TABLE `rd_ip_update_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_id` int(11) DEFAULT NULL COMMENT '自建系统id',
  `ip_id` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip变动列表',
  `apply_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请单号',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请内容',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `apply_user_id` int(11) DEFAULT NULL COMMENT '申请人id\r\n',
  `create_time` datetime DEFAULT NULL COMMENT '申请日期',
  `type` int(3) DEFAULT NULL COMMENT '操作类型 0-新增 1-修改',
  `current_state` int(11) DEFAULT NULL COMMENT '当前状态（1未提交、2待审批 3发动到审批模块、4审批中、5已撤回、6审批通过、7已驳回）',
  `is_done` int(3) DEFAULT NULL COMMENT '是否完成',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=587 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ip修改申请';

-- ----------------------------
--  Records of `rd_ip_update_application`
-- ----------------------------
BEGIN;
INSERT INTO `rd_ip_update_application` VALUES ('585', '96', '792', '1587437800234-20200421105640234409', '用户:张大微修改自建系统生成了IP申请单', '37', '237', '2020-04-21 10:56:40', '0', '4', '0'), ('586', '98', '793', '1587893650712-20200426173410712354', '用户:向学义修改自建系统生成了IP申请单', '35', '233', '2020-04-26 17:34:11', '0', '3', '0');
COMMIT;

-- ----------------------------
--  Table structure for `rd_order_app`
-- ----------------------------
DROP TABLE IF EXISTS `rd_order_app`;
CREATE TABLE `rd_order_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_num` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单号',
  `sys_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统名称',
  `version_num` int(11) DEFAULT NULL COMMENT '版本号',
  `sys_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统code',
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统包含的ip',
  `ip_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip的id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user` int(11) DEFAULT NULL COMMENT '创建人',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modify_user` int(11) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=373 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='订单关联自建系统表';

-- ----------------------------
--  Records of `rd_order_app`
-- ----------------------------
BEGIN;
INSERT INTO `rd_order_app` VALUES ('366', '20200420145317873961-501', '省政府办公厅对外自建系统', null, '839f7d8d-8ddc-4333-a2a7-79516f7840be', '10.1.12.163,10.1.12.164,10.1.12.165', '287,288,289', '2020-04-20 14:53:18', '237', null, null), ('367', '20200422101847599725-502', '省政府办公厅对外自建系统', null, '839f7d8d-8ddc-4333-a2a7-79516f7840be', '10.1.12.163,10.1.12.164,10.1.12.165', '287,288,289', '2020-04-22 10:18:48', '237', null, null), ('368', '20200422171749800747-501', '地图系统', null, '0c7137f3-a82c-4d2a-8466-a9e1c1c535ba', '166.152.152.155', '292', '2020-04-22 17:17:50', '233', null, null), ('369', '20200427110427741360-506', '人社系统', null, '1850cef1-6903-404f-8f93-8f1c18f9a7e8', '162.155.155.102', '296', '2020-04-27 11:04:28', '233', null, null), ('370', '20200427114645878479-502', '地图系统', null, '0c7137f3-a82c-4d2a-8466-a9e1c1c535ba', '166.152.152.155', '292', '2020-04-27 11:46:46', '233', null, null), ('371', '20200427160527558468-523', '地图系统', null, '0c7137f3-a82c-4d2a-8466-a9e1c1c535ba', '166.152.152.155', '292', '2020-04-27 16:05:28', '233', null, null), ('372', '20200427160608252425-524', '人社系统', null, '1850cef1-6903-404f-8f93-8f1c18f9a7e8', '162.155.155.102', '296', '2020-04-27 16:06:08', '233', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_parameter_information`
-- ----------------------------
DROP TABLE IF EXISTS `rd_parameter_information`;
CREATE TABLE `rd_parameter_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parameter_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '参数名称',
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '类型',
  `necessary` int(11) DEFAULT NULL COMMENT '是否必填(0.是   1.否)',
  `explains` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '说明',
  `instance_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '示例值',
  `primary_key` int(11) DEFAULT NULL COMMENT '是否主键(1.是  2.否)',
  `parameter_type` int(11) DEFAULT NULL COMMENT '参数类型（0.请求参数  1.返回参数）',
  `own_res_id` int(11) DEFAULT NULL COMMENT '所属资源API ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1252 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='参数信息-请求and返回参数';

-- ----------------------------
--  Records of `rd_parameter_information`
-- ----------------------------
BEGIN;
INSERT INTO `rd_parameter_information` VALUES ('1110', 'areaCode', 'String', '0', '城区编号', null, '2', '0', '120'), ('1111', 'defineParkingCode', 'String', '0', '市里定义规则的停车场编号', null, '2', '0', '120'), ('1112', 'parkingId', 'int', '0', '停车场 id（主键）', null, '2', '0', '120'), ('1113', 'buildType', 'Int', '0', '建筑类型', null, '2', '1', '120'), ('1114', 'attachedType', 'Int', '0', '配建类型', null, '2', '1', '120'), ('1115', 'parkingName', 'String', '0', '停车场名称', null, '2', '1', '120'), ('1116', 'data', 'Object', '0', '返回内容信息', null, '2', '1', '120'), ('1117', 'openTime', 'String', '0', '开放时间', null, '2', '1', '120'), ('1118', 'tempTotalNum', 'Int', '0', '临停车位数', null, '2', '1', '120'), ('1119', 'openBerthNum', 'Int', '0', '开放泊位数', null, '2', '1', '120'), ('1120', 'intrinsicTotalNum', 'Int', '0', '月租车位数', null, '2', '1', '120'), ('1121', 'visitorTotalNum', 'Int', '0', '访客车位数', null, '2', '1', '120'), ('1122', 'parkingLocate', 'Int', '0', '停车位置', null, '2', '1', '120'), ('1123', 'parkingType', 'Int', '0', '停车场类型', null, '2', '1', '120'), ('1124', 'result_code', 'String', '0', '结果代码信号', null, '2', '1', '120'), ('1125', 'parkingPattern', 'Int', '0', '停车场模式', null, '2', '1', '120'), ('1126', 'regionCode', 'String', '0', '行政区划', null, '2', '1', '120'), ('1127', 'areaCode', 'String', '0', '城区编号', null, '2', '1', '120'), ('1128', 'priceType', 'Int', '0', '定价类型', null, '2', '1', '120'), ('1129', 'totalBerthNum', 'Int', '0', '泊位总数', null, '2', '1', '120'), ('1130', 'msg', 'String', '0', '结果状态描述', null, '2', '1', '120'), ('1131', 'parkingCode', 'String', '0', '停车场编号', null, '2', '1', '120'), ('1132', 'address', 'String', '0', '停车场地址', null, '2', '1', '120'), ('1133', 'age', 'string', '0', '年龄', null, '2', '1', '123'), ('1134', 'cardId', 'String', '0', '身份证号码', null, '2', '0', '123'), ('1135', 'sign', 'String', '0', '请求签名，格式：APP_KEY + 请求秘钥+时间戳 经过MD5加密 生成的串', null, '2', '0', '123'), ('1136', 'appKey', 'String', '0', '应用APP_KEY，一个应用对应一个固定不变的字符串', null, '2', '0', '123'), ('1137', 'requestTime', 'String', '0', '请求时间，是以long类型的字符串', null, '2', '0', '123'), ('1138', 'WS99_99_902_176', 'String', '0', '消息业务类型代码', null, '2', '0', '124'), ('1139', 'CT08_10_052_01', 'String', '0', '机构名称', null, '2', '0', '124'), ('1140', 'WS99_99_903_59', 'String', '0', '消息ID', null, '2', '0', '124'), ('1141', 'WS99_99_902_510', 'String', '0', '是否重发', null, '2', '0', '124'), ('1142', 'WS08_10_052_01', 'String', '0', '机构编码', null, '2', '0', '124'), ('1143', 'CT02_01_038_01', 'String', '0', '行政区划名称', null, '2', '0', '124'), ('1144', 'WS99_99_241_340', 'String', '0', '户籍是否办结', null, '2', '0', '124'), ('1145', 'WS06_00_994_02', 'String', '0', '统计时间', null, '2', '0', '124'), ('1146', 'WS02_01_038_01', 'String', '0', '行政区划代码', null, '2', '0', '124'), ('1147', 'WS99_99_241_341', 'String', '0', '医保是否办结', null, '2', '0', '124'), ('1148', 'WS99_99_241_342', 'String', '0', '市民卡是否办结', null, '2', '0', '124'), ('1149', 'CT99_99_902_176', 'String', '0', '消息业务类型名称', null, '2', '0', '124'), ('1150', 'WS99_00_930_08', 'String', '0', '申报号码', null, '2', '0', '124'), ('1151', 'WS99_99_013_50', 'String', '0', '发送时间', null, '2', '0', '124'), ('1152', 'msg', 'String', '0', '调用结果', null, '2', '1', '124'), ('1153', 'data', 'String', '0', '数据', null, '2', '1', '124'), ('1154', 'result_code', 'String', '0', '状态码', null, '2', '1', '124'), ('1155', 'id_nbr', 'String', '0', '身份证', null, '2', '0', '125'), ('1156', 'name', 'String', '0', '姓名', null, '2', '0', '125'), ('1157', 'result_code', 'String', '0', '结果代码信号', null, '2', '1', '125'), ('1158', 'msg', 'String', '0', '结果状态描述', null, '2', '1', '125'), ('1159', 'data', 'Object', '0', '返回内容信息', null, '2', '1', '125'), ('1160', 'gender', 'string', '0', '性别', null, '2', '1', '125'), ('1161', 'name', 'string', '0', '姓名', null, '2', '1', '125'), ('1162', 'idnty_nbr', 'string', '0', '身份证号', null, '2', '1', '125'), ('1163', 'brith_dt', 'string', '0', '出生日期', null, '2', '1', '125'), ('1164', 'polc_statn', 'string', '0', '发证机关', null, '2', '1', '125'), ('1165', 'trst_addr', 'string', '0', '户籍地址', null, '2', '1', '125'), ('1166', 'id_nbr', 'String', '0', '身份证', null, '2', '0', '126'), ('1167', 'name', 'String', '0', '姓名', null, '2', '0', '126'), ('1168', 'result_code', 'String', '0', '结果代码信号', null, '2', '1', '126'), ('1169', 'msg', 'String', '0', '结果状态描述', null, '2', '1', '126'), ('1170', 'data', 'Object', '0', '返回内容信息', null, '2', '1', '126'), ('1171', 'id_nbr', 'string', '0', '身份证', null, '2', '1', '126'), ('1172', 'gender', 'string', '0', '性别', null, '2', '1', '126'), ('1173', 'name', 'string', '0', '姓名', null, '2', '1', '126'), ('1174', 'birth_date', 'string', '0', '出生日期', null, '2', '1', '126'), ('1175', 'addr', 'string', '0', '户籍地址', null, '2', '1', '126'), ('1176', 'issue_mecha', 'string', '0', '发证机关', null, '2', '1', '126'), ('1177', 'person_stat', 'string', '0', '人员状态', null, '2', '1', '126'), ('1178', 'end_date', 'String', '0', '有效期限截止日期', null, '2', '1', '126'), ('1179', 'begin_date', 'String', '0', '有效期限起始日期', null, '2', '1', '126'), ('1180', 'national', 'String', '0', '民族', null, '2', '1', '126'), ('1181', 'xm', 'String', '0', '申请人姓名', null, '2', '0', '127'), ('1182', 'sfzh', 'String', '0', '身份证号', null, '2', '0', '127'), ('1183', 'NAME', 'varchar(100)', '0', '申请人姓名', null, '2', '1', '127'), ('1184', 'PO_CMPNY_NAME', 'varchar(100)', '0', '配偶单位名称', null, '2', '1', '127'), ('1185', 'CHNGE_RSN', 'VARCHAR2(500)', '0', '变更原因', null, '2', '1', '127'), ('1186', 'PO_WORK_INFO', 'NUMBER(8)', '0', '配偶供职情况', null, '2', '1', '127'), ('1187', 'AUDT_NBR', 'varchar(50)', '0', '审批号', null, '2', '1', '127'), ('1188', 'WORK_INFO', 'NUMBER(8)', '0', '申请人供职情况', null, '2', '1', '127'), ('1189', 'PO_CMPNY_ID', 'varchar(50)', '0', '配偶单位编号', null, '2', '1', '127'), ('1190', 'PO_NAME', 'varchar(100)', '0', '配偶姓名', null, '2', '1', '127'), ('1191', 'CUR_AMT', 'NUMBER (9,2)', '0', '本次应补贴金额(总计应补贴金额－变更前应补贴金额)', null, '2', '1', '127'), ('1192', 'PO_ID_NBR', 'varchar(50)', '0', '配偶身份证号', null, '2', '1', '127'), ('1193', 'AUDT_DT', 'Date', '0', '审批日期', null, '2', '1', '127'), ('1194', 'CMPNY_NAME', 'varchar(100)', '0', '申请人单位名称', null, '2', '1', '127'), ('1195', 'CMPNY_ID', 'varchar(50)', '0', '申请人单位编号', null, '2', '1', '127'), ('1196', 'SBSDY_TYPE', 'NUMBER(8)', '0', '业务类型(普通住房补贴（10），企业住房补贴（20）)', null, '2', '1', '127'), ('1197', 'SUM_AMT', 'NUMBER (9,2)', '0', '总计应补贴金额(总补贴额－单位补助)', null, '2', '1', '127'), ('1198', 'ID_NBR', 'varchar(50)', '0', '申请人身份证号', null, '2', '1', '127'), ('1199', 'cardId', 'string', '0', '身份证件号码', null, '2', '0', '128'), ('1200', 'appKey', 'string', '0', '应用APP_KEY，一个应用对应一个固定不变的字符串', null, '2', '0', '128'), ('1201', 'sign', 'string', '0', '请求签名，格式：APP_KEY + 请求秘钥+时间戳 经过MD5加密 生成的串', null, '2', '0', '128'), ('1202', 'requestTime', 'string', '0', '请求时间，是以long类型的字符串', null, '2', '0', '128'), ('1203', 'code', 'string', '0', '结果00成功，01请求参数异常', null, '2', '1', '128'), ('1204', 'msg', 'string', '0', '结果信息', null, '2', '1', '128'), ('1205', 'datas', 'string', '0', 'datas说明：', null, '2', '1', '128'), ('1206', 'name', 'string', '0', '姓名', null, '2', '1', '128'), ('1207', 'sex', 'string', '0', '性别', null, '2', '1', '128'), ('1208', 'cardId', 'string', '0', '身份证号', null, '2', '1', '128'), ('1209', 'censusAddr', 'string', '0', '户籍地址', null, '2', '1', '128'), ('1210', 'passPortNumber', 'string', '0', '护照号码', null, '2', '1', '128'), ('1211', 'birthAddr', 'string', '0', '出生地', null, '2', '1', '128'), ('1212', 'birthday', 'string', '0', '出生日期', null, '2', '1', '128'), ('1213', 'populationSerialNo', 'string', '0', '人口序列号', null, '2', '1', '128'), ('1214', 'realAddr', 'string', '0', '实际居住地', null, '2', '1', '128'), ('1215', 'nation', 'string', '0', '民族', null, '2', '1', '128'), ('1216', 'app_key', 'String', '0', 'key', null, '2', '1', '129'), ('1217', 'requestSecret', 'String', '0', '秘钥', null, '2', '1', '129'), ('1218', 'ly_bal', 'String', '0', '上年余额', null, '2', '1', '130'), ('1219', 'name', 'String', '0', '姓名', null, '2', '0', '130'), ('1220', 'bran_code', 'String', '0', '分中心机构代码', null, '2', '1', '130'), ('1221', 'pscale', 'String', '0', '个人缴存比例', null, '2', '1', '130'), ('1222', 'status', 'String', '0', '个人缴存状态', null, '2', '1', '130'), ('1223', 'remark', 'String', '0', '备注', null, '2', '1', '130'), ('1224', 'idnbr', 'String', '0', '身份证', null, '2', '0', '130'), ('1225', 'set_date', 'String', '0', '登记日期', null, '2', '1', '130'), ('1226', 'matter', 'String', '0', '认证发起原由/事项中文名称', null, '2', '0', '131'), ('1227', 'autograph', 'String', '0', '认证结果pdf是否需要电子签章（0:需要 1：不需要；非必传，不上传则默认为0，需要电子签章)', null, '2', '0', '131'), ('1228', 'id_nbr', 'String', '0', '身份证号', null, '2', '0', '131'), ('1229', 'name', 'String', '0', '姓名', null, '2', '0', '131'), ('1230', 'way', 'String', '0', '身份信息来源(0:人工输入，1：读卡，不传则默认为0)', null, '2', '0', '131'), ('1231', 'pic', 'String', '0', '人像照片（Base64编码）', null, '2', '0', '131'), ('1232', 'deptCode', 'String', '0', '认证来源（部门编码）', null, '2', '0', '131'), ('1233', 'type', 'String', '0', '认证结果pdf中是否需要包含被认证人签名确认(0:包含 1：不包含，不上传则默认为0)', null, '2', '0', '131'), ('1234', 'serialNumber', 'String', '0', '认证流水号', null, '2', '1', '131'), ('1235', 'message', 'String', '0', '认证结果说明', null, '2', '1', '131'), ('1236', 'result_code', 'String', '0', '结果代码信号', null, '2', '1', '131'), ('1237', 'result', 'String', '0', '认证结果base64编码', null, '2', '1', '131'), ('1238', 'data', 'JSONArray', '0', '返回内容信息', null, '2', '1', '131'), ('1239', 'code', 'String', '0', '结果代码', null, '2', '1', '131'), ('1240', 'msg', 'String', '0', '结果状态描述', null, '2', '1', '131'), ('1241', 'authResult', 'String', '0', '认证结果代码（由4位字符代码表示）', null, '2', '1', '131'), ('1242', 'name', 'String', '0', '姓名', null, '2', '1', '131'), ('1243', 'sfzs', 'String', '0', '身份证号', null, '2', '1', '131'), ('1244', 'addr', 'String', '0', '地址', null, '2', '1', '131'), ('1245', 'date', 'String', '0', '数据', null, '2', '0', '132'), ('1246', 'success', 'String', '0', '是否成功', null, '2', '1', '132'), ('1247', 'msg', 'String', '0', '调用结果信息', null, '2', '1', '132'), ('1248', 'name', 'String', '0', '姓名', null, '2', '0', '133'), ('1249', 'data', 'String', '0', '数据返回', null, '2', '1', '133'), ('1250', 'result_code', 'String', '0', '结果编码', null, '2', '1', null), ('1251', 'data', 'JsonArray', '0', '数据', null, '2', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_res_basic_information`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_basic_information`;
CREATE TABLE `rd_res_basic_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `information_resource_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '信息资源名称',
  `res_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源关键字',
  `category_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '类目名称',
  `info_res_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '信息资源描述',
  `late_update_user_id` int(11) DEFAULT NULL COMMENT '最后更新人员id',
  `own_res_id` int(11) DEFAULT NULL COMMENT '所属资源id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源详情-数据源-基本信息';

-- ----------------------------
--  Table structure for `rd_res_catalog_table_info`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_catalog_table_info`;
CREATE TABLE `rd_res_catalog_table_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_catalog_id` int(11) DEFAULT NULL COMMENT '关联的资源编目的ID',
  `col_ch_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段中文名称',
  `col_en_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段英文名称\r\n\r\n',
  `col_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段类型',
  `col_length` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段长度',
  `col_precesion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段精度',
  `is_key` int(3) DEFAULT NULL COMMENT '是否为主键: 0-否 1-是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='保存资源目录中存放的表结构';

-- ----------------------------
--  Table structure for `rd_res_create_info`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_create_info`;
CREATE TABLE `rd_res_create_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_id` int(11) DEFAULT NULL COMMENT '创建资源id',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建该资源的用户id',
  `create_dept_id` int(11) DEFAULT NULL COMMENT '资源所属部门id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='部门用户创建资源时记录创建信息';

-- ----------------------------
--  Records of `rd_res_create_info`
-- ----------------------------
BEGIN;
INSERT INTO `rd_res_create_info` VALUES ('233', '500', '234', '22997', '2020-04-18 21:37:39'), ('234', '518', '234', '22997', '2020-04-20 15:02:11'), ('237', '521', '234', '22997', '2020-04-22 16:18:01'), ('238', '522', '234', '22997', '2020-04-22 16:37:04'), ('239', '523', '234', '22997', '2020-04-27 15:47:41'), ('240', '524', '234', '22997', '2020-04-27 15:50:00'), ('241', '525', '236', '1', '2020-06-15 10:39:56');
COMMIT;

-- ----------------------------
--  Table structure for `rd_res_data_item`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_data_item`;
CREATE TABLE `rd_res_data_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `english_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '英文名称',
  `chinese_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '中文名称',
  `field_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段类型',
  `field_length` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段长度',
  `field_accuracy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字段精度',
  `keywords` int(11) DEFAULT NULL COMMENT '是否主键（1.是 2.否）',
  `own_res_id` int(11) DEFAULT NULL COMMENT '所属资源id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=620 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源详情-数据源-数据项';

-- ----------------------------
--  Records of `rd_res_data_item`
-- ----------------------------
BEGIN;
INSERT INTO `rd_res_data_item` VALUES ('606', 'name', '姓名', 'char', '255', '1', '1', '500', '2020-04-18 21:52:46'), ('607', 'name', '姓名', 'char', '11', '1', '2', '518', '2020-04-20 15:04:44'), ('608', 'age', '年龄', 'char', '3', '1', '2', '518', '2020-04-20 15:04:44'), ('609', 'card', '省份证号', 'char', '255', '1', '2', '518', '2020-04-20 15:04:44'), ('612', 'name', '姓名', 'char', '20', '', '2', '521', '2020-04-22 16:23:55'), ('613', 'idCard', '身份证', 'char', '18', '', '2', '521', '2020-04-22 16:23:55'), ('614', 'code', '唯一识别码', 'char', '50', '', '1', '521', '2020-04-22 16:23:55'), ('615', 'user', '用户信息', 'char', '200', '', '2', '522', '2020-04-22 16:37:36'), ('616', 'name', '姓名', 'char', '1', '1', '1', '523', '2020-04-27 15:48:42'), ('617', 'address', '地址', 'char', '1', '1', '1', '523', '2020-04-27 15:48:42'), ('618', 'name', '1', 'char', '1', '1', '1', '524', '2020-04-27 15:50:35'), ('619', 'address', '地址', 'char', '1', '1', '1', '524', '2020-04-27 15:50:35');
COMMIT;

-- ----------------------------
--  Table structure for `rd_res_details_api`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_details_api`;
CREATE TABLE `rd_res_details_api` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_dir_id` int(11) DEFAULT NULL COMMENT '资源ID',
  `interface_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口名称',
  `interface_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口类型',
  `interface_state` int(11) DEFAULT NULL COMMENT '接口状态(1.异常  2.正常）',
  `request_type` int(3) DEFAULT NULL COMMENT ' 请求方式（1.GET  2.POST   3.Webservice 4.H5地图',
  `support_format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '支持格式',
  `api_desc` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口描述',
  `api_address` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口地址',
  `request_demo` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '请求示例 : json字符串',
  `return_demo` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '返回示例: json字符串',
  `modify_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源详情API';

-- ----------------------------
--  Records of `rd_res_details_api`
-- ----------------------------
BEGIN;
INSERT INTO `rd_res_details_api` VALUES ('117', '501', '全国互联网地图信息查询', null, '1', '4', null, '使用leaflet方式使用', 'http://192.168.1.246:50021/DCSBWeb/h5servlets/33.1111.qghlwdtxxcx.SynReq@1.0', '/tile/4/5/8', '地图切片', null, '2020-04-20 10:47:48'), ('118', '502', '浙江杭州规划和自然资源局天地图信息查询（leaflet）', null, '1', '4', null, '返回地图瓦片图片', 'http://192.168.1.246:50021/DCSBWeb/h5servlets/33.1111.zjhz.ghhzrzyjtdtxxcx.SynReq@1.0', '/tile/4/5/8', '地图瓦片图片', null, '2020-04-20 10:47:54'), ('119', '503', '浙江省浙政钉组织架构部门详情查询', null, '1', '1', null, null, 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.dir.dir10001.SynReq@1.0', null, null, null, '2020-04-20 10:47:56'), ('120', '504', '浙江杭州城管局停车场信息查询', null, '1', '1', null, '杭州城市大脑停车系统中的停车场基本信息共享，调用周期：定时，调用条件：停车场基本信息变更时。', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.dir.dir10000.SynReq@1.0', 'String areaCode  = \"城区编号\";\nString defineParkingCode = \"市里定义规则的停车场编号\";\nJSONObject json = new JSONObject();\njson.put(\"areaCode\",areaCode);\njson.put(\"defineParkingCode\",defineParkingCode);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");', '{\n\"msg\": \"操作成功\",\n\"result_code\": \"200\",\n\"data\": [\n		{\n		\"parkingCode\": \"停车场编号\",\n		\"parkingName\": \"停车场名称\",\n		\"address\": \"停车场地址\",\n		\"regionCode\": \"行政区划\",\n		\"areaCode\": \"城区编号\",\n		\"priceType\": 定价类型,\n		\"inroadFeesType\": \"路内停车收费类型\",\n		\"feeScale\": \"收费标准\",\n		\"openTime\": \"开放时间\",\n		\"parkingPattern\": 停车场模式,\n		\"parkingLocate\": 停车位置,\n		\"parkingType\": 停车场类型,\n		\"attachedType\": \"配建类型\",\n		\"buildType\": 建筑类型,\n		\"totalBerthNum\": 泊位总数,\n		\"openBerthNum\": 开放泊位数,\n		\"x\": \"国家大地坐标系经度坐标\",\n		\"y\": \"国家大地坐标系纬度坐标\",\n		\"bmapX\": \"百度经度坐标\",\n		\"bmapY\": \"百度纬度坐标\",\n		\"gmapX\": \"高德经度坐标\",\n		\"gmapY\": \"高德纬度坐标\",\n		\"tempTotalNum\": 临停车位数,\n		\"intrinsicTotalNum\": 月租车位数,\n		\"visitorTotalNum\": 访客车位数,\n		\"chargeTotalNum\": 充电桩车位数,\n		\"isuse\": 是否在用,\n		\"isOpen\":是否开放,\n		\"defineParkingCode\":\"市里定义规则的停车场编号\"\n		}\n	]，\n}', null, '2020-04-20 10:47:59'), ('121', '505', '浙江杭州公安局流动人口信息查询', null, '1', '1', null, '该服务暂无说明', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.sgaj.gajldrkxxcx.SynReq@1.0', 'json', null, null, '2020-04-20 10:48:01'), ('122', '506', '浙江杭州民政局低保人口信息查询', null, '1', '1', null, null, 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.smzx.mzjdbrkxxcx.SynReq@1.0', null, null, null, '2020-04-20 10:48:04'), ('123', '507', '浙江杭州公安户籍信息查询', null, '1', '2', null, 'http post接口，Content-Type为multipart/form-data，用于人脸身份认证，返回结构化数据，包含认证结果pdf文件base64编码', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.smzx.gajhjxxcx.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:05'), ('124', '508', '浙江杭州卫健委出生一件事办理进度查询', null, '1', '2', null, 'http post接口，Content-Type为multipart/form-data，用于人脸身份认证，返回结构化数据，包含认证结果pdf文件base64编码', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.smzx.JGSSTSGL.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:09'), ('125', '509', '浙江杭州公安暂住人口信息查询', null, '1', '2', null, '获取公安暂住人口信息。', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.smzx.gajnonresident.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:11'), ('126', '510', '浙江杭州常驻人口信息查询', null, '1', '2', null, '常驻人口信息查询', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.gajczrkxxcx.SynReq@2.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:14'), ('127', '511', '浙江杭州住保房管局住房补贴电子数据查询', null, '1', '3', null, '获取杭州住保房管局住房补贴电子数据信息', 'http://192.168.1.246:50021/DCSBWeb/services/33.1111.zjhz.smzx.zbfgjDzzzServicePort.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:15'), ('128', '512', '浙江省人口信息查询', null, '1', '2', null, 'http post接口，Content-Type为multipart/form-data，用于人脸身份认证，返回结构化数据，包含认证结果pdf文件base64编码', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zj.popInfo.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:18'), ('129', '513', '浙江省接口秘钥申请', null, '1', '1', null, '省接口调用之前先访问秘钥接口获取加密所需的appkey', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zj.appkeyAndrequestToken.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:20'), ('130', '514', '浙江杭州公积金基本信息查询', null, '1', '2', null, '获取公积金基本信息(详细说明及demo问题请联系技术人员：凌江，电话：114)', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.smzx.gongjijinbasicinfo.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\n	\"msg\":\"操作成功\",\n	\"result_code\":\"200\",\n	\"data\":[\n		{\n			\"id_nbr\":\"身份证号\",\n			\"abs_code\":\"摘要代码\",\n			\"pay_amt\":月缴存额,\n			\"cpay_amt\":单位月缴存额,\n			\"acct_type\":\"业务类型\",\n			\"last_dt\":\"最近缴存月份\",\n			\"dept_name\":\"单位名称\",\n			\"curr_bal\":当年余额,\n			\"remark\":\"备注\",\n			\"pay_base\":缴存基数,\n			\"set_date\":\"登记日期\",\n			\"cscale\":单位缴存比例,\n			\"cust_no\":\"个人客户号\",\n			\"name\":\"姓名\",\n			\"acct_no\":\"个人资金账号\",\n			\"ppay_amt\":个人月缴存额,\n			\"sum_bal\":合计余额,\n			\"ly_bal\":上年余额,\n			\"pscale\":个人缴存比例,\n			\"bran_code\":\"分中心机构代码\",\n			\"status\":\"个人缴存状态\"\n		}\n	]\n}', null, '2020-04-20 10:48:24'), ('131', '515', '浙江杭州数据资源局可信身份认证(pdf)', null, '1', '2', null, 'http post接口，Content-Type为multipart/form-data，用于人脸身份认证，返回结构化数据，包含认证结果pdf文件base64编码', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.smzx.sjzyjauthenticatepdf.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\r\n	\"msg\":\"查询成功\",\r\n	\"data\":[\r\n		{\r\n			\"authResult\":\"认证结果代码\",\r\n			\"code\":\"结果代码\",\r\n			\"message\":\"认证结果说明\",\r\n			\"name\":\"姓名\",\r\n			\"result\":\"认证结果base64编码\",\r\n			\"serialNumber\":\"认证流水号\",\r\n			\"sfz\":\"身份证号\"\r\n		}\r\n	],\r\n	\"result_code\":\"200\"\r\n}', null, '2020-04-20 10:48:25'), ('132', '516', 'DCSB标准服务信息查询', null, '1', '1', null, 'http post接口，Content-Type为multipart/form-data，用于人脸身份认证，返回结构化数据，包含认证结果pdf文件base64编码', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.dcsbbzfwxxcx.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:28'), ('133', '517', 'DCSB服务模拟', null, '1', '2', null, '查询发布的服务信息', 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.dcsbfwmn.SynReq@1.0', 'JSONObject json = new JSONObject();\njson.put(\"id_nbr\",id_nbr);\njson.put(\"name\",name);\nString request= RSAUtils.encryptByPrivateKey(json.toJSONString(), privateKey);\nString sign=RSAUtils.sign(request,privateKey);\nPart[] parts= new Part[2];\nparts[0] = new StringPart(\"request\", request,\"UTF-8\");\nparts[1] = new StringPart(\"sign\", sign,\"UTF-8\");\nString res = HttpReqUtils.post4Multipart(url,parts);', '{\"msg\":\"操作成功\",\"result_code\":\"200\",\"data\":[{\"gender\":\"\",\"name\":\"\",\"idnty_nbr\":\"\",\"brith_dt\":\"\",\"polc_statn\":\"\",\"trst_addr\":\"\"}]}', null, '2020-04-20 10:48:28'), ('134', '523', '城市绿码申请人员信息查询', null, null, null, null, null, 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.dcsbfwmn.SynReq@1.0', null, null, null, null), ('135', '524', '城市红码人员信息查询', null, null, null, null, null, 'http://192.168.1.246:50021/DCSBWeb/servlets/33.1111.zjhz.dcsbfwmn.SynReq@1.0', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_res_for_online`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_for_online`;
CREATE TABLE `rd_res_for_online` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `application_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单号',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id（主键）',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `state` int(11) DEFAULT NULL COMMENT '当前状态（0未确认 1未提交、2待审批、3已提交至审批中心、4审批中、5已撤回、6审批通过、7已驳回）',
  `apply_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请部门名称',
  `contact_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系人姓名',
  `contact_tel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系人手机',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请说明',
  `enclosure` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件',
  `application_type` int(11) DEFAULT NULL COMMENT '订单类型(1-正常订单 2-购物车订单 3-服务咨询订单)',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `apply_user_id` int(11) DEFAULT NULL COMMENT '申请人id',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `modify_user_id` int(11) DEFAULT NULL COMMENT '修改人员id',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `version_num` int(11) DEFAULT NULL COMMENT '版本号',
  `preselect_res` int(11) DEFAULT NULL COMMENT '当前节点能否预选资源类型',
  `res_type` int(11) DEFAULT NULL COMMENT '资源类型(1.服务接口类 2.服务页面类 3.数据交换类)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=331 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='未上线资源申请单';

-- ----------------------------
--  Records of `rd_res_for_online`
-- ----------------------------
BEGIN;
INSERT INTO `rd_res_for_online` VALUES ('325', '20200420150818689317-518', '518', '晚婚晚育人员信息查询接口', '6', '省政府办公厅', '张大微', '13302105824', '申请上线', '', null, '37', '237', '2020-04-20 15:08:19', null, null, null, null, '3'), ('328', '20200422162717374705-521', '521', '人员信息普查接口', '3', '市数据资源管理局', '申陶宜', '13300006597', '申请使用', '', null, '22997', '234', '2020-04-22 16:27:17', null, null, null, null, '3'), ('329', '20200422163806819280-522', '522', '接口服务模拟', '6', '省人大', '向学义', '13300002130', '申请使用', '', null, '35', '233', '2020-04-22 16:38:07', null, null, null, null, '3');
COMMIT;

-- ----------------------------
--  Table structure for `rd_res_management`
-- ----------------------------
DROP TABLE IF EXISTS `rd_res_management`;
CREATE TABLE `rd_res_management` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `src_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '来源部门名称',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源管理,关联用户所拥有资源';

-- ----------------------------
--  Records of `rd_res_management`
-- ----------------------------
BEGIN;
INSERT INTO `rd_res_management` VALUES ('148', '500', '237', '37', '浙江省', null, '2020-04-20 11:25:33'), ('149', '501', '237', '37', '浙江省', null, '2020-04-21 10:52:45'), ('150', '502', '237', '37', '浙江省', null, '2020-04-22 10:19:50'), ('151', '501', '233', '35', '浙江省', null, '2020-04-22 17:20:09'), ('152', '518', '237', '37', '', null, '2020-04-27 11:10:39'), ('153', '506', '233', '35', '浙江省', null, '2020-04-27 11:11:59'), ('154', '500', '233', '35', '浙江省', null, '2020-04-27 11:12:01'), ('155', '524', '233', '35', '', null, '2020-04-27 16:06:46'), ('156', '523', '233', '35', '', null, '2020-04-27 16:06:52');
COMMIT;

-- ----------------------------
--  Table structure for `rd_resource_application_all`
-- ----------------------------
DROP TABLE IF EXISTS `rd_resource_application_all`;
CREATE TABLE `rd_resource_application_all` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请单号',
  `apply_user_id` int(11) DEFAULT NULL COMMENT '申请人id',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `apply_dept_id` int(11) DEFAULT NULL COMMENT '申请人部门id',
  `modify_user_id` int(11) DEFAULT NULL COMMENT '修改人id',
  `modify_depe_id` int(11) DEFAULT NULL COMMENT '修改人部门id',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源申请栏（总）';

-- ----------------------------
--  Table structure for `rd_resource_application_detail`
-- ----------------------------
DROP TABLE IF EXISTS `rd_resource_application_detail`;
CREATE TABLE `rd_resource_application_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_num_father` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '总订单号',
  `apply_num_child` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '子订单号',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `state` int(11) DEFAULT NULL COMMENT '当前状态（0未确认 1未提交、2待审批、3已提交至审批中心、4审批中、5已撤回、6审批通过、7已驳回）',
  `apply_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请部门名称',
  `apply_user_id` int(11) DEFAULT NULL COMMENT '申请人id',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `res_type` int(11) DEFAULT NULL COMMENT '资源类型(1.服务接口类 2.服务页面类 3.数据交换类)',
  `res_situation` int(11) DEFAULT NULL COMMENT '归集情况(1.已归集 2.未归集)',
  `contact_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系人姓名',
  `contact_tel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系人手机',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请说明',
  `type` int(11) DEFAULT NULL COMMENT '订单类型(1-正常订单 2-购物车订单 3-服务咨询订单)',
  `enclosure` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `modify_user_id` int(11) DEFAULT NULL COMMENT '修改人id',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `version_num` int(11) DEFAULT NULL COMMENT '版本信息',
  `db_id` int(11) DEFAULT NULL COMMENT 'rd_db_dict的主键',
  `item_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'item的主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=684 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='申请单（申请使用）';

-- ----------------------------
--  Records of `rd_resource_application_detail`
-- ----------------------------
BEGIN;
INSERT INTO `rd_resource_application_detail` VALUES ('662', '20200420103608505327', '20200420103608505327-500', '500', '7', '省政府办公厅', '237', '37', '浙江省户口迁移准许接口申请', '3', '1', '张大微', '18556355920', '查询', '3', '', '2020-04-20 10:36:09', null, null, '1', '160', '606'), ('663', '20200420103608505327', '20200420103608505327-500', '500', '6', '省政府办公厅', '237', '37', '浙江省户口迁移准许接口申请', '3', '1', '张大微', '18556355920', '查询：编入**项目接口，提供相关非隐私数据。', '3', '', '2020-04-20 10:36:09', '237', '2020-04-20 11:23:35', null, '160', '606'), ('664', '20200420145317873961', '20200420145317873961-501', '501', '6', '省政府办公厅', '237', '37', '全国互联网地图信息查询', '1', '1', '张大微', '13302108546', '申请查询', '1', 'c3991347-0a67-4b04-80ef-a7215c80ab45', '2020-04-20 14:53:18', null, null, null, null, ''), ('665', '20200420153807641262', '20200420153807641563-502', '502', '1', '省政府办公厅', '237', '37', '浙江杭州规划和自然资源局天地图信息查询（leaflet）', '1', '1', null, null, null, '2', null, '2020-04-20 15:38:08', null, null, null, null, null), ('666', '20200420153941426391', '20200420153941426657-503', '503', '1', '省政府办公厅', '237', '37', '浙江省浙政钉组织架构部门详情查询', '1', '1', null, null, null, '2', null, '2020-04-20 15:39:41', null, null, null, null, null), ('667', '20200420154240708925', '20200420154240708540-518', '518', '1', '省政府办公厅', '237', '37', '晚婚晚育人员信息查询接口', '2', '1', null, null, null, '2', null, '2020-04-20 15:42:41', null, null, null, null, null), ('668', '20200420154535113458', '20200420154535113882-518', '518', '1', '浙江省', '236', '1', '晚婚晚育人员信息查询接口', '2', '1', null, null, null, '2', null, '2020-04-20 15:45:35', null, null, null, null, null), ('669', '20200420154535758730', '20200420154535758116-504', '504', '1', '浙江省', '236', '1', '浙江杭州城管局停车场信息查询', '1', '1', null, null, null, '2', null, '2020-04-20 15:45:36', null, null, null, null, null), ('670', '20200420154536757767', '20200420154536757112-503', '503', '1', '浙江省', '236', '1', '浙江省浙政钉组织架构部门详情查询', '1', '1', null, null, null, '2', null, '2020-04-20 15:45:37', null, null, null, null, null), ('671', '20200421104150664604', '20200421104150664604-518', '518', '6', '省政府办公厅', '237', '37', '晚婚晚育人员信息查询接口', '2', '1', '张大微', '133345679876', '查询数据啊 ', '2', '', '2020-04-21 10:41:51', null, null, null, null, ''), ('672', '20200422101847599725', '20200422101847599725-502', '502', '6', '省政府办公厅', '237', '37', '浙江杭州规划和自然资源局天地图信息查询（leaflet）', '1', '1', '大卫', '13302157474', '测试', '1', '', '2020-04-22 10:18:48', null, null, null, null, ''), ('673', '20200422171749800747', '20200422171749800747-501', '501', '6', '省人大', '233', '35', '全国互联网地图信息查询', '1', '1', '向学义', '13300003210', '申请使用', '1', '', '2020-04-22 17:17:50', null, null, null, null, ''), ('674', '20200422173042520254', '20200422173042520567-505', '505', '1', '省人大', '233', '35', '浙江杭州公安局流动人口信息查询', '1', '1', null, null, null, '2', null, '2020-04-22 17:30:43', null, null, null, null, null), ('675', '20200422173043490146', '20200422173043490157-504', '504', '1', '省人大', '233', '35', '浙江杭州城管局停车场信息查询', '1', '1', null, null, null, '2', null, '2020-04-22 17:30:43', null, null, null, null, null), ('676', '20200422174813074244', '20200422174813074244-500', '500', '6', '省人大', '233', '35', '浙江省户口迁移准许接口申请', '3', '1', '向学义', '13300003210', '申请使用', '3', '', '2020-04-22 17:48:13', null, null, null, '161', '606'), ('677', '20200427110427741360', '20200427110427741360-506', '506', '6', '省人大', '233', '35', '浙江杭州民政局低保人口信息查询', '1', '1', '向学义', '13300000005', '申请使用', '1', '2c7de7a3-607a-48d9-87a7-3dfe2dacfd7c', '2020-04-27 11:04:28', null, null, null, null, ''), ('678', '20200427114645878479', '20200427114645878479-502', '502', '3', '省人大', '233', '35', '浙江杭州规划和自然资源局天地图信息查询（leaflet）', '1', '1', '向向', '13302103589', '查询', '1', '', '2020-04-27 11:46:46', null, null, null, null, ''), ('679', '20200427160527558468', '20200427160527558468-523', '523', '6', '省人大', '233', '35', '城市绿码申请人员信息查询', '1', '1', '张微', '17703439586', '查询', '1', '', '2020-04-27 16:05:28', null, null, null, null, ''), ('680', '20200427160608252425', '20200427160608252425-524', '524', '6', '省人大', '233', '35', '城市红码人员信息查询', '1', '1', '张伟', '13308569865', '查询', '1', '', '2020-04-27 16:06:08', null, null, null, null, ''), ('681', '20200610173810631415', '20200610173810631540-524', '524', '1', '浙江省', '1', '1', '城市红码人员信息查询', '1', '1', null, null, null, '2', null, '2020-06-10 17:38:11', null, null, null, null, null), ('682', '20200615102656856145', '20200615102656856383-523', '523', '1', '浙江省', '236', '1', '城市绿码申请人员信息查询', '1', '1', null, null, null, '2', null, '2020-06-15 10:26:57', null, null, null, null, null), ('683', '20200615102659971917', '20200615102659971796-511', '511', '1', '浙江省', '236', '1', '浙江杭州住保房管局住房补贴电子数据查询', '1', '1', null, null, null, '2', null, '2020-06-15 10:27:00', null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_resource_cataloging`
-- ----------------------------
DROP TABLE IF EXISTS `rd_resource_cataloging`;
CREATE TABLE `rd_resource_cataloging` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `own_res_id` int(11) DEFAULT NULL COMMENT '所属资源id',
  `catalog_type` int(3) DEFAULT NULL COMMENT '编目方式 0-数据源 1-格式化文件',
  `add_type` int(3) DEFAULT NULL COMMENT '录入方式 0-文件导入 1-手工录入',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `dept_id` int(11) DEFAULT NULL COMMENT '所属部门',
  `share_type` int(11) DEFAULT NULL COMMENT '共享方式(1.受限2.公开)',
  `update_frequency` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '更新频率',
  `cataloging_description` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '信息资源摘要',
  `cataloging_tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源关键字',
  `cataloging_time` datetime DEFAULT NULL COMMENT '编目时间',
  `is_release` int(11) DEFAULT NULL COMMENT '是否发布（1是 2.否）',
  `dept_data_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '部门数据源',
  `cataloging_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编目表名',
  `exchange_user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交换对接人',
  `phone_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系方式',
  `collection` int(11) DEFAULT NULL COMMENT '允许归集（1.是  2.否）',
  `open_to_out` int(11) DEFAULT NULL COMMENT '是否对外开放(1.是 2.否)',
  `open_preview` int(11) DEFAULT NULL COMMENT '开放预览(1.是 2.否)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源编目';

-- ----------------------------
--  Table structure for `rd_resource_dir`
-- ----------------------------
DROP TABLE IF EXISTS `rd_resource_dir`;
CREATE TABLE `rd_resource_dir` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_dcsb_id` int(11) DEFAULT NULL COMMENT 'dcsb平台数据id',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `res_power` int(11) DEFAULT NULL COMMENT '资源权限状态（1.公开 2.受限）',
  `collection_situation` int(11) DEFAULT NULL COMMENT '归集情况(1.已归集 2.未归集)',
  `res_type` int(11) DEFAULT NULL COMMENT '资源类型(1.服务接口类 2.服务页面类 3.数据交换类)',
  `is_release` int(3) DEFAULT NULL COMMENT '是否发布(0-未发布   1-已发布)',
  `res_get_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源来源部门',
  `res_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源唯一标识',
  `res_source_dept` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源提供部门',
  `res_source_dept_id` int(11) DEFAULT NULL COMMENT '资源提供部门ID',
  `modify_user_id` int(11) DEFAULT NULL COMMENT '修改人id',
  `res_level` int(11) DEFAULT NULL COMMENT '资源层级（1.省级 2.市级 3.区级）可以先空着',
  `is_fail` int(3) DEFAULT NULL COMMENT '是否失效 0失效  1 有效',
  `res_state` int(3) DEFAULT NULL COMMENT '资源状态 ( 1 . 正常  2. 异常)',
  `res_power_dept` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源权限部门名称',
  `res_power_dept_id` int(11) DEFAULT NULL COMMENT '资源权限部门 : (审批部门)',
  `own_app` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '所属系统名称',
  `update_frequency` int(3) DEFAULT NULL COMMENT '更新频率  实时1、每小时2、每天3、每月4、每季度5、每半年6、每年7、不更新8，不定时9',
  `modify_time` datetime DEFAULT NULL COMMENT '修改日期',
  `release_time` datetime DEFAULT NULL COMMENT '发布时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `preselect_res_type` int(11) DEFAULT NULL COMMENT '预选资源类型(1.服务接口类 2.服务页面类 3.数据交换类)',
  `rd_resource_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源说明',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=526 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源目录(总表)';

-- ----------------------------
--  Records of `rd_resource_dir`
-- ----------------------------
BEGIN;
INSERT INTO `rd_resource_dir` VALUES ('500', null, '浙江省户口迁移准许接口申请', '2', '1', '3', '1', '浙江省数据据', '376c52fb-d8b9-4b64-9df7-31093a5b583d', '市数据资源管理局', '22997', null, '1', null, '1', '浙江省', '1', null, '1', '2020-04-18 21:43:47', '2020-04-18 21:41:10', '2020-04-18 21:37:39', null, '申请户口迁移'), ('501', '1061', '全国互联网地图信息查询', '2', '1', '1', '1', null, 'da634860-5cd1-486a-8b8f-f687187a97e7', '浙江省人民政府办公厅', '37', null, '1', '1', '1', '浙江省', '1', 'DCSB', '2', '2020-04-22 14:32:03', '2020-04-20 14:25:24', '2020-04-20 10:47:48', null, null), ('502', '1042', '浙江杭州规划和自然资源局天地图信息查询（leaflet）', '2', '1', '1', '1', null, '3c044e27-0a0e-4851-b272-cc4caec30f7a', '浙江省', '1', null, '1', '1', '1', '浙江省', '1', 'DCSB', '1', '2020-04-20 15:32:50', '2020-04-20 15:32:51', '2020-04-20 10:47:54', null, null), ('503', '1008', '浙江省浙政钉组织架构部门详情查询', '2', '1', '1', '1', null, 'ac0eba4f-2688-4cff-ba9e-fa915a779e6f', '浙江省人民政府办公厅', '37', null, '1', '1', '1', '浙江省', '1', 'DCSB', '1', '2020-04-20 15:38:45', '2020-04-20 15:38:45', '2020-04-20 10:47:56', null, null), ('504', '1007', '浙江杭州城管局停车场信息查询', '1', '1', '1', '1', null, '9ddbd7d2-46de-4c40-af94-362a2b339514', '省人大', '35', null, '1', '1', '1', '市数据资源管理局', '22997', 'DCSB', '1', '2020-04-20 15:38:52', '2020-04-20 15:38:52', '2020-04-20 10:47:59', null, null), ('505', '1006', '浙江杭州公安局流动人口信息查询', '2', '1', '1', '1', null, '6361afe8-07e2-49fd-8e23-b551b25857bb', '市公安局', '22510', null, '1', '1', '1', '浙江省', '1', 'DCSB', '1', '2020-04-21 14:33:49', '2020-04-21 14:33:49', '2020-04-20 10:48:01', null, null), ('506', '1003', '浙江杭州民政局低保人口信息查询', '2', '1', '1', '1', null, '542c9ca6-34fc-4b09-baa1-c5273ffaa939', '市民政局', '22547', null, '1', '1', '1', '浙江省', '1', 'DCSB', '1', '2020-04-22 19:02:33', '2020-04-22 19:02:33', '2020-04-20 10:48:04', null, null), ('507', '102', '浙江杭州公安户籍信息查询1', '2', '1', '1', '0', null, 'df19e69a-f64b-443b-b8c7-76c9b2f8037d', '浙江省', '1', null, '1', '1', '1', '浙江省', '1', 'DCSB', '1', '2020-04-24 10:31:50', '2020-04-24 10:31:54', '2020-04-20 10:48:05', null, null), ('508', '101', '浙江杭州卫健委出生一件事办理进度查询', '2', '1', '1', '0', null, '70c3ae04-150d-4a10-9a17-932518c8205c', '省人大', '35', null, '1', '1', '1', null, null, 'DCSB', '4', '2020-04-20 10:48:09', null, '2020-04-20 10:48:09', null, null), ('509', '98', '浙江杭州公安暂住人口信息查询', '2', '1', '1', '0', null, '7cc0fb81-a04d-4dbb-959a-4caab4ea7202', '市数据资源管理局', '22997', null, '1', '1', '1', null, null, 'DCSB', '3', '2020-04-20 10:48:11', null, '2020-04-20 10:48:11', null, null), ('510', '90', '浙江杭州常驻人口信息查询', '2', '1', '1', '0', null, '35b17f2c-9bad-4440-a36e-d889c1bf421a', '龙湾区', '47616', null, '1', '1', '1', null, null, 'DCSB', '3', '2020-04-20 10:48:14', null, '2020-04-20 10:48:14', null, null), ('511', '84', '浙江杭州住保房管局住房补贴电子数据查询', '1', '1', '1', '1', null, '084636bd-1fd8-4bb4-838a-ae3f18ab2ffe', '省人大', '35', null, '1', '1', '1', '市数据资源管理局', null, 'DCSB', '1', '2020-04-24 11:39:28', '2020-04-24 11:39:18', '2020-04-20 10:48:15', null, null), ('512', '83', '浙江省人口信息查询', '2', '1', '1', '0', null, '7bd5b2ae-0d5a-4cbe-b4e3-626292612c38', '浙江省', '1', null, '1', '1', '1', null, null, 'DCSB', '1', '2020-04-20 10:48:18', null, '2020-04-20 10:48:18', null, null), ('513', '80', '浙江省接口秘钥申请', '2', '1', '1', '0', null, '6f9a87a2-4805-491f-b14d-ce2663fa983b', '省人大', '35', null, '1', '1', '1', null, null, 'DCSB', '1', '2020-04-20 10:48:20', null, '2020-04-20 10:48:20', null, null), ('514', '78', '浙江杭州公积金基本信息查询', '2', '1', '1', '0', null, '570e90ec-556b-4d34-b532-1d42bcd23fec', '市数据资源管理局', '22997', null, '1', '1', '1', null, null, 'DCSB', '1', '2020-04-20 10:48:24', null, '2020-04-20 10:48:24', null, null), ('515', '33', '浙江杭州数据资源局可信身份认证(pdf)', '2', '1', '1', '0', null, '9736bb24-3e7f-4e9e-8057-974f7e4d1e2d', '市数据资源管理局', '22997', null, '1', '1', '1', null, null, 'DCSB', '1', '2020-04-20 10:48:25', null, '2020-04-20 10:48:25', null, null), ('516', '25', 'DCSB标准服务信息查询', '2', '1', '1', '0', null, '846679f5-01ae-4655-b7b6-e1876c6c96dd', '省政协办公厅', '2072', null, '1', '1', '1', null, null, 'DCSB', '1', '2020-04-20 10:48:28', null, '2020-04-20 10:48:28', null, null), ('517', '24', 'DCSB服务模拟', '2', '1', '1', '0', null, '1fd0ba08-6b34-4c4f-931c-20b588e18a36', '浙江省人民政府办公厅', '37', null, '1', '1', '1', null, null, 'DCSB', '1', '2020-04-20 10:48:28', null, '2020-04-20 10:48:28', null, null), ('518', null, '晚婚晚育人员信息查询接口', '1', '1', '2', '0', '人口管理部门', '88c825e5-7865-421e-8080-961875e88515', '市数据资源管理局', '22997', null, '3', null, '1', '', '22997', null, '1', '2020-04-22 16:11:47', '2020-04-20 15:12:44', '2020-04-20 15:02:11', '3', '查询大龄晚婚晚育人口信息'), ('521', null, '人员信息普查接口', '1', '2', '3', '1', '', 'eb39c6c6-40d8-4940-a917-51b9d5b0c028', '市数据资源管理局', '22997', null, null, null, '1', '', null, null, '4', '2020-04-22 16:18:01', '2020-04-22 16:18:01', '2020-04-22 16:18:01', null, ''), ('522', null, '接口服务模拟', '1', '2', '3', '1', '', '06286c09-3009-49be-8466-886e29d3ed68', '市数据资源管理局', '22997', null, '2', null, '1', '', null, null, '4', '2020-04-24 11:18:59', '2020-04-22 16:37:04', '2020-04-22 16:37:04', '3', ''), ('523', null, '城市绿码申请人员信息查询', '1', '1', '1', '1', '卫建委', 'd75c5251-0939-4128-a653-7ec9bfc72ed2', '市数据资源管理局', '22997', null, '2', null, '1', '', null, null, '2', '2020-04-27 15:47:41', '2020-04-27 15:47:41', '2020-04-27 15:47:41', null, '绿码人员信息'), ('524', null, '城市红码人员信息查询', '1', '1', '1', '1', '数据局', '0684e7f2-7918-419f-8ad0-545948d98ff9', '市数据资源管理局', '22997', null, '2', null, '1', '', null, null, '1', '2020-04-27 15:50:00', '2020-04-27 15:50:00', '2020-04-27 15:50:00', null, '红码'), ('525', null, '11111111111', '1', '2', '3', '0', '', 'af15c775-31b1-4cc4-bd71-19aeaef85f0f', '浙江省', '1', null, '1', null, '1', '', null, null, null, '2020-06-15 10:39:56', null, '2020-06-15 10:39:56', null, '');
COMMIT;

-- ----------------------------
--  Table structure for `rd_resource_dir_data`
-- ----------------------------
DROP TABLE IF EXISTS `rd_resource_dir_data`;
CREATE TABLE `rd_resource_dir_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `res_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源关键字',
  `category_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '类目名称',
  `res_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源描述',
  `res_dir_id` int(11) DEFAULT NULL COMMENT '所属资源ID',
  `add_type` int(3) DEFAULT NULL COMMENT '录入方式:0-文件导入 1-手动导入',
  `catalog_type` int(3) DEFAULT NULL COMMENT '编目方式:0-数据源 1-格式化文件',
  `exchange_user_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交换对接人',
  `phone_num` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系方式',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creat_user_id` int(11) DEFAULT NULL COMMENT '创建人id',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modify_user_id` int(11) DEFAULT NULL COMMENT '修改人id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源目录-数据源';

-- ----------------------------
--  Records of `rd_resource_dir_data`
-- ----------------------------
BEGIN;
INSERT INTO `rd_resource_dir_data` VALUES ('162', null, null, null, null, '500', '1', '0', '申陶宜', '13300000234', '2020-04-18 21:52:46', '234', null, null), ('163', null, null, null, null, '518', '1', '0', '数据据数据提供部门', '17743869527', '2020-04-20 15:04:44', '234', null, null), ('166', null, null, null, null, '521', '1', '0', '申陶宜', '', '2020-04-22 16:23:55', '234', null, null), ('167', null, null, null, null, '522', '1', '0', '申陶宜', '', '2020-04-22 16:37:36', '234', null, null), ('168', null, null, null, null, '523', '1', '0', '申陶宜', '17503210358', '2020-04-27 15:48:42', '234', null, null), ('169', null, null, null, null, '524', '1', '0', '申陶宜', '13346448596', '2020-04-27 15:50:35', '234', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `rd_self_built_system`
-- ----------------------------
DROP TABLE IF EXISTS `rd_self_built_system`;
CREATE TABLE `rd_self_built_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `sys_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统名称',
  `sys_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统代码',
  `sys_describe` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统描述',
  `sys_state` int(3) DEFAULT NULL COMMENT '自建系统状态:0-正常 1-作废',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) DEFAULT NULL COMMENT '自建系统关联用户id',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间\r\n',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='自建系统';

-- ----------------------------
--  Records of `rd_self_built_system`
-- ----------------------------
BEGIN;
INSERT INTO `rd_self_built_system` VALUES ('95', '省社保服务系统', '0505a9a5-d93d-4c2d-9dda-a537f3aecbe2', '', '0', '1', '0', '2020-04-20 10:04:17', '2020-04-20 10:01:59'), ('96', '省政府办公厅对外自建系统', '839f7d8d-8ddc-4333-a2a7-79516f7840be', '省政府办公厅对外自建系统（对外对接专用）。', '0', '37', '0', '2020-04-21 10:56:40', '2020-04-20 14:52:30'), ('97', '数据局自建系统数据', 'd283e981-2f66-4b76-be80-0384960fbb36', '测试', '0', '22997', '234', null, '2020-04-22 10:12:27'), ('98', '地图系统', '0c7137f3-a82c-4d2a-8466-a9e1c1c535ba', '', '0', '35', '0', '2020-04-26 17:34:11', '2020-04-22 17:17:28'), ('99', '省政府办公厅自建系统2', '9939aa48-9aea-4eb2-97c5-e213d00cca9b', '测试数据', '0', '37', '237', null, '2020-04-24 15:38:04'), ('100', '人社系统', '1850cef1-6903-404f-8f93-8f1c18f9a7e8', '', '0', '35', '233', null, '2020-04-27 11:03:41');
COMMIT;

-- ----------------------------
--  Table structure for `rd_system_ip`
-- ----------------------------
DROP TABLE IF EXISTS `rd_system_ip`;
CREATE TABLE `rd_system_ip` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `relf_sys_id` int(11) DEFAULT NULL COMMENT '关联自建系统id',
  `ip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip地址',
  `res_id_list` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '关联资源id列表',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=297 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='自建系统绑定IP表';

-- ----------------------------
--  Records of `rd_system_ip`
-- ----------------------------
BEGIN;
INSERT INTO `rd_system_ip` VALUES ('286', '95', '5.159.245.233', null, '2020-04-20 10:01:59'), ('287', '96', '10.1.12.163', '501,502', '2020-04-20 14:52:30'), ('288', '96', '10.1.12.164', '501,502', '2020-04-20 14:52:30'), ('289', '96', '10.1.12.165', '501,502', '2020-04-20 14:52:30'), ('290', '97', '133.1.1.2', null, '2020-04-22 10:12:27'), ('291', '97', '133.1.1.3', null, '2020-04-22 10:12:27'), ('292', '98', '166.152.152.155', '523', '2020-04-22 17:17:28'), ('293', '99', '192.168.99.9', null, '2020-04-24 15:38:04'), ('294', '99', '192.168.99.10', null, '2020-04-24 15:38:04'), ('295', '99', '192.168.99.11', null, '2020-04-24 15:38:04'), ('296', '100', '162.155.155.102', '524,506', '2020-04-27 11:03:41');
COMMIT;

-- ----------------------------
--  Table structure for `reply_info`
-- ----------------------------
DROP TABLE IF EXISTS `reply_info`;
CREATE TABLE `reply_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `requirement_id` int(11) DEFAULT NULL COMMENT '需求id',
  `requirement_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '需求名称',
  `requirement_type` int(255) DEFAULT NULL COMMENT '需求类型(1.数据需求 2.问题反馈)',
  `requirement_state` int(255) DEFAULT NULL COMMENT '需求状态(1.待处理 2.已流转 3.已回复)',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `instructions_detail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请详细说明',
  `reply_dept_id` int(11) DEFAULT NULL COMMENT '回复部门id',
  `reply_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '回复部门名称',
  `reply_info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '回复内容',
  `require_dept_id` int(11) DEFAULT NULL COMMENT '需求申请部门id',
  `require_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '需求申请部门名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='互动交流-回复信息';

-- ----------------------------
--  Records of `reply_info`
-- ----------------------------
BEGIN;
INSERT INTO `reply_info` VALUES ('47', '35', '问题1', '2', '1', '2020-04-24 10:51:41', '', '22997', '市数据资源管理局', null, '22997', '市数据资源管理局'), ('48', '36', '轻武器', '1', '1', '2020-06-09 15:09:51', '去', '22997', '市数据资源管理局', null, '22997', '市数据资源管理局'), ('49', '37', 'test', '1', '1', '2020-06-15 11:27:15', 'wo xuyao 某个资源，请民政局归集', '22997', '市数据资源管理局', null, '1', '浙江省');
COMMIT;

-- ----------------------------
--  Table structure for `requirement_info`
-- ----------------------------
DROP TABLE IF EXISTS `requirement_info`;
CREATE TABLE `requirement_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' 需求id',
  `requirement_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '需求名称',
  `requirement_type` int(255) DEFAULT NULL COMMENT '需求类型(1.数据需求 2.问题反馈)',
  `requirement_state` int(255) DEFAULT NULL COMMENT '需求状态(1.待回复 2.已回复)',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `instructions_detail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请详细说明',
  `reply_dept_id` int(11) DEFAULT NULL COMMENT '回复部门id',
  `reply_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '回复部门名称',
  `reply_info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '回复内容',
  `require_dept_id` int(11) DEFAULT NULL COMMENT '需求申请部门id',
  `require_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '需求申请部门名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='互动交流-问题反馈信息';

-- ----------------------------
--  Records of `requirement_info`
-- ----------------------------
BEGIN;
INSERT INTO `requirement_info` VALUES ('35', '问题1', '2', '1', '2020-04-24 10:51:41', '', '22997', '市数据资源管理局', null, '22997', '市数据资源管理局'), ('36', '轻武器', '1', '1', '2020-06-09 15:09:51', '去', '22997', '市数据资源管理局', null, '22997', '市数据资源管理局'), ('37', 'test', '1', '1', '2020-06-15 11:27:15', 'wo xuyao 某个资源，请民政局归集', '22997', '市数据资源管理局', null, '1', '浙江省');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
